Pagination Offset

dReveal's grid pagination control has been enhanced to improve performance and flexibility. A new pagination method, leveraging SQL OFFSET FETCH clauses, has been introduced to calculate the total row count within a single query.

Override Hierarchy

The Pagination Offset configuration follows a cascading hierarchy. Each level overrides the settings from the previous level:

Report Definition (Outer Level): The Pagination Offset checkbox within the report definition holds the most granular control. Enabling it execution for that specific report.

Application Level: Programmatic configuration can override the report definition setting. This allows for adjustments based on specific application needs.

Server Level: The dReveal configuration on the server is the most global setting overriding any report definition or application-level configurations.